<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
{{assign var="title" value='表结构'}}
<title>{{$title}}管理 - {{'admin|admin_site_name'|C|default:'后台管理'}}</title>
{{include file="include/base.html"}}
</head>
<body>

{{include file="include/sidebar.html"}}
<div class="body_right">
	<div id="content">

	<table class="table table-bordered">
		<tr class="thead">
			<td colspan="9">
			  ◆ 结构
			</td>
		</tr>
		<tr class="ttitle">
			<th>Field</th>
			<th>Type</th>
			<th>Collation</th>
			<th>Null</th>
			<th>Key</th>
			<th>Default</th>
			<th>Extra</th>
			<th>Privileges</th>
			<th>Comment</th>
		</tr>

		<tbody>
			{{section name=loop loop=$list1}}
			<tr>
				<td>{{$list1[loop].Field}}</td>
				<td>{{$list1[loop].Type}}</td>
				<td>{{$list1[loop].Collation}}</td>
				<td>{{$list1[loop].Null}}</td>
				<td>{{$list1[loop].Key}}</td>
				<td>{{$list1[loop].Default}}</td>
				<td>{{$list1[loop].Extra}}</td>
				<td>{{$list1[loop].Privileges}}</td>
				<td>{{$list1[loop].Comment}}</td>
			</tr>
		    {{/section}}
		</tbody>
	</table>
	
    <br/>
	
    <table class="table table-bordered">
		<tr class="thead">
			<td colspan="10">
			  ◆ 索引
			</td>
		</tr>
		<tr class="ttitle">
			<th>Keyname</th>
			<th>Type</th>
			<th>Unique</th>
			<th>Packed</th>
			<th>Seq_in_index</th>
			<th>Field</th>
			<th>Cardinality</th>
			<th>Collation</th>
			<th>Null</th>
			<th>Comment</th>
		</tr>	 	 	 	 	 	 	 	
		<tbody>
			{{section name=loop loop=$list2}}
			<tr>
				<td>{{$list2[loop].Key_name}}</td>
				<td>{{$list2[loop].Index_type}}</td>
				<td>{{$list2[loop].Non_unique}}</td>
				<td>{{$list2[loop].Packed}}</td>
				<td>{{$list2[loop].Seq_in_index}}</td>
				<td>{{$list2[loop].Column_name}}</td>
				<td>{{$list2[loop].Cardinality}}</td>
				<td>{{$list2[loop].Collation}}</td>
				<td>{{$list2[loop].Null}}</td>
				<td>{{$list2[loop].Comment}}</td>
			</tr>
		    {{/section}}
		</tbody>
	</table>
	
</div>
</div>

</body>
</html>